package com.pxxy.lawconsult.constant;

public class DBConstant {

	// 数据库所要用到的常量
	public static final String DB_URL = "jdbc:mysql://120.77.205.137/law_conslut?serverTimezone=GMT%2B8";
	public static final String DB_USERNAME = "jzx";
	public static final String DB_USERPASSWORD = "1697749396";
	public static final String DB_DRIVER = "com.mysql.cj.jdbc.Driver";

	// user表
	public static final String TB_USER_TABLE = "usersb";
	public static final String USER_TABLE_ID = "id";
	public static final String USER_TABLE_TEL = "tel";
	public static final String USER_TABLE_PASSWORD = "password";
	public static final String USER_TABLE_IMAGE = "image";
	public static final String USER_TABLE_TYPE = "type";

	// client表
	public static final String TB_CLIENT_TABLE = "clientb";
	public static final String CLIENT_TABLE_CLIENT_ID = "client_ID";
	public static final String CLIENT_TABLE_SIGNATURE = "signature";
	public static final String CLIENT_TABLE_CLIENT_SEX = "client_sex";
	public static final String CLIENT_TABLE_CLIENT_EMAIL = "client_email";
	public static final String CLIENT_TABLE_USER_ID = "user_ID";
	public static final String CLIENT_TABLE_NICKNAME = "nickname";

	// lawer表
	public static final String TB_LAWER_TABLE = "lawerb";
	public static final String LAWER_TABLE_LAWER_ID = "lawer_ID";
	public static final String LAWER_TABLE_LAWER_NAME = "lawer_name";
	public static final String LAWER_TABLE_LAWER_AGE = "lawer_age";
	public static final String LAWER_TABLE_LAWER_SEX = "lawer_sex";
	public static final String LAWER_TABLE_LAWER_TEL = "lawer_tel";
	public static final String LAWER_TABLE_LAWER_EMAIL = "lawer_email";
	public static final String LAWER_TABLE_NUMBER = "number";
	public static final String LAWER_TABLE_SPECIALITY = "speciality";
	public static final String LAWER_TABLE_OFFICE = "office";
	public static final String LAWER_TABLE_INTRODUCTION = "Introduction";
	public static final String LAWER_TABLE_USER_ID = "user_id";
	public static final String LAWER_TABLE_LAWER_ADDRESS = "address";
	
	//案例表
	public static final String TB_CASE_TABLE = "caseb";
	public static final String CASE_TABLE_CASE_ID = "case_id";
	public static final String CASE_TABLE_CASE_TYPE = "case_type";
	public static final String CASE_TABLE_CASE_CONTENT = "case_content";
	public static final String CASE_TABLE_CASE_TITLE = "case_title";
	public static final String CASE_TABLE_CASE_TIME = "case_time";
	public static final String CASE_TABLE_CASE_IMAGE = "case_image";

}
